Profiling Report

Dataset statistics

Number of variables	39
Number of observations	46927
Missing cells	243508
Missing cells (%)	13.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	13.3 MiB
Average record size in memory	298.0 B

Variable types

Numeric	12
DateTime	5
Text	5
Categorical	15
Boolean	2

Alerts

`no_of_adults` is highly overall correlated with `no_of_room`	High correlation
`no_of_room` is highly overall correlated with `no_of_adults`	High correlation
`language` is highly overall correlated with `original_payment_currency`	High correlation
`original_payment_currency` is highly overall correlated with `language`	High correlation
`accommadation_type_name` is highly imbalanced (64.5%)	Imbalance
`no_of_extra_bed` is highly imbalanced (96.1%)	Imbalance
`original_payment_method` is highly imbalanced (58.3%)	Imbalance
`original_payment_type` is highly imbalanced (91.4%)	Imbalance
`request_latecheckin` is highly imbalanced (82.6%)	Imbalance
`request_airport` is highly imbalanced (93.7%)	Imbalance
`request_earlycheckin` is highly imbalanced (78.8%)	Imbalance
`request_nonesmoke` has 20030 (42.7%) missing values	Missing
`request_latecheckin` has 20030 (42.7%) missing values	Missing
`request_highfloor` has 20030 (42.7%) missing values	Missing
`request_largebed` has 20030 (42.7%) missing values	Missing
`request_twinbeds` has 20030 (42.7%) missing values	Missing
`request_airport` has 20030 (42.7%) missing values	Missing
`request_earlycheckin` has 20030 (42.7%) missing values	Missing
`hotel_brand_code` has 34699 (73.9%) missing values	Missing
`hotel_chain_code` has 34343 (73.2%) missing values	Missing
`cancellation_datetime` has 34250 (73.0%) missing values	Missing
`original_selling_amount` is highly skewed (γ1 = 36.55009602)	Skewed
`h_booking_id` has unique values	Unique
`hotel_star_rating` has 2060 (4.4%) zeros	Zeros
`no_of_children` has 42690 (91.0%) zeros	Zeros

Reproduction

Analysis started	2023-06-07 20:00:00.748945
Analysis finished	2023-06-07 20:00:41.154730
Duration	40.41 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

h_booking_id
Real number (ℝ)

Distinct	46927
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.7482761 × 10¹⁶

Minimum	-9.2231941 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	23545
Negative (%)	50.2%
Memory size	366.7 KiB

Quantile statistics

Minimum	-9.2231941 × 10¹⁸
5-th percentile	-8.3231332 × 10¹⁸
Q1	-4.6146133 × 10¹⁸
median	-3.2064787 × 10¹⁶
Q3	4.5760991 × 10¹⁸
95-th percentile	8.2846133 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Range	-2.1169456 × 10¹⁴
Interquartile range (IQR)	9.1907124 × 10¹⁸

Descriptive statistics

Standard deviation	5.3247643 × 10¹⁸
Coefficient of variation (CV)	-304.57227
Kurtosis	-1.1991323
Mean	-1.7482761 × 10¹⁶
Median Absolute Deviation (MAD)	4.5955943 × 10¹⁸
Skewness	0.0033792406
Sum	-8.756789 × 10¹⁸
Variance	2.8353114 × 10³⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.861445259 × 10¹⁸	1	< 0.1%
-5.859385366 × 10¹⁸	1	< 0.1%
4.102580392 × 10¹⁸	1	< 0.1%
1.795941529 × 10¹⁸	1	< 0.1%
-5.721949141 × 10¹⁸	1	< 0.1%
-4.284526584 × 10¹⁸	1	< 0.1%
2.103613272 × 10¹⁸	1	< 0.1%
5.236811047 × 10¹⁸	1	< 0.1%
-2.3832694 × 10¹⁸	1	< 0.1%
-2.788888768 × 10¹⁸	1	< 0.1%
Other values (46917)	46917	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.223194056 × 10¹⁸	1	< 0.1%
-9.222713784 × 10¹⁸	1	< 0.1%
-9.222411208 × 10¹⁸	1	< 0.1%
-9.222220846 × 10¹⁸	1	< 0.1%
-9.220467519 × 10¹⁸	1	< 0.1%
-9.219746746 × 10¹⁸	1	< 0.1%
-9.219730436 × 10¹⁸	1	< 0.1%
-9.219588531 × 10¹⁸	1	< 0.1%
-9.219312947 × 10¹⁸	1	< 0.1%
-9.219139934 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
9.223338324 × 10¹⁸	1	< 0.1%
9.223221736 × 10¹⁸	1	< 0.1%
9.222651807 × 10¹⁸	1	< 0.1%
9.222015612 × 10¹⁸	1	< 0.1%
9.221958225 × 10¹⁸	1	< 0.1%
9.221798878 × 10¹⁸	1	< 0.1%
9.221611986 × 10¹⁸	1	< 0.1%
9.221457559 × 10¹⁸	1	< 0.1%
9.220807687 × 10¹⁸	1	< 0.1%
9.220787994 × 10¹⁸	1	< 0.1%

booking_datetime
Date

Distinct	41260
Distinct (%)	87.9%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	2017-07-02 18:58:00
Maximum	2018-09-30 10:32:00

Histogram

Histogram with fixed size bins (bins=50)

checkin_date
Date

Distinct	105
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	2018-06-07 00:00:00
Maximum	2018-09-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

checkout_date
Date

Distinct	91
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	2018-07-02 00:00:00
Maximum	2018-09-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

hotel_id
Real number (ℝ)

Distinct	24969
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1341712.9

Minimum	1
Maximum	5823993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	10917.6
Q1	255829
median	798535
Q3	2284662
95-th percentile	4168202
Maximum	5823993
Range	5823992
Interquartile range (IQR)	2028833

Descriptive statistics

Standard deviation	1361519.7
Coefficient of variation (CV)	1.0147624
Kurtosis	0.077266214
Mean	1341712.9
Median Absolute Deviation (MAD)	675419
Skewness	1.0483226
Sum	6.296256 × 10¹⁰
Variance	1.853736 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6452	273	0.6%
461790	54	0.1%
304294	46	0.1%
3080111	42	0.1%
337607	36	0.1%
185945	34	0.1%
1603143	34	0.1%
43450	33	0.1%
4426497	32	0.1%
1270365	32	0.1%
Other values (24959)	46311	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	< 0.1%
16	2	< 0.1%
75	2	< 0.1%
85	1	< 0.1%
99	3	< 0.1%
122	2	< 0.1%
140	1	< 0.1%
148	1	< 0.1%
153	1	< 0.1%
168	4	< 0.1%

Value	Count	Frequency (%)
5823993	1	< 0.1%
5808200	1	< 0.1%
5799579	1	< 0.1%
5798032	1	< 0.1%
5797970	1	< 0.1%
5795465	1	< 0.1%
5790845	1	< 0.1%
5785518	1	< 0.1%
5771209	1	< 0.1%
5761104	1	< 0.1%

hotel_country_code
Text

Distinct	125
Distinct (%)	0.3%
Missing	4
Missing (%)	< 0.1%
Memory size	366.7 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	93846
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	AU
2nd row	JP
3rd row	TW
4th row	TR
5th row	JP

Value	Count	Frequency (%)
jp	7357	15.7%
th	6331	13.5%
my	6136	13.1%
tw	4062	8.7%
id	2883	6.1%
kr	2718	5.8%
ph	2128	4.5%
vn	2105	4.5%
us	1445	3.1%
hk	1295	2.8%
Other values (115)	10463	22.3%

Most occurring characters

Value	Count	Frequency (%)
T	11398	12.1%
H	10432	11.1%
P	9669	10.3%
J	7410	7.9%
M	6873	7.3%
Y	6162	6.6%
K	4676	5.0%
N	4205	4.5%
W	4086	4.4%
I	4060	4.3%
Other values (16)	24875	26.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	93846	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	11398	12.1%
H	10432	11.1%
P	9669	10.3%
J	7410	7.9%
M	6873	7.3%
Y	6162	6.6%
K	4676	5.0%
N	4205	4.5%
W	4086	4.4%
I	4060	4.3%
Other values (16)	24875	26.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93846	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	11398	12.1%
H	10432	11.1%
P	9669	10.3%
J	7410	7.9%
M	6873	7.3%
Y	6162	6.6%
K	4676	5.0%
N	4205	4.5%
W	4086	4.4%
I	4060	4.3%
Other values (16)	24875	26.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93846	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	11398	12.1%
H	10432	11.1%
P	9669	10.3%
J	7410	7.9%
M	6873	7.3%
Y	6162	6.6%
K	4676	5.0%
N	4205	4.5%
W	4086	4.4%
I	4060	4.3%
Other values (16)	24875	26.5%

hotel_live_date
Date

Distinct	17476
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	1999-09-09 00:00:00
Maximum	2019-04-18 10:17:00

Histogram

Histogram with fixed size bins (bins=50)

hotel_star_rating
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2239968

Minimum	-1
Maximum	5
Zeros	2060
Zeros (%)	4.4%
Negative	1
Negative (%)	< 0.1%
Memory size	366.7 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1722628
Coefficient of variation (CV)	0.36360543
Kurtosis	0.72713638
Mean	3.2239968
Median Absolute Deviation (MAD)	1
Skewness	-0.79401111
Sum	151292.5
Variance	1.3742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3	14061	30.0%
4	12531	26.7%
5	5053	10.8%
2	5018	10.7%
3.5	3389	7.2%
0	2060	4.4%
2.5	1752	3.7%
1	1342	2.9%
4.5	1174	2.5%
1.5	546	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	2060	4.4%
1	1342	2.9%
1.5	546	1.2%
2	5018	10.7%
2.5	1752	3.7%
3	14061	30.0%
3.5	3389	7.2%
4	12531	26.7%
4.5	1174	2.5%

Value	Count	Frequency (%)
5	5053	10.8%
4.5	1174	2.5%
4	12531	26.7%
3.5	3389	7.2%
3	14061	30.0%
2.5	1752	3.7%
2	5018	10.7%
1.5	546	1.2%
1	1342	2.9%
0	2060	4.4%

accommadation_type_name
Categorical

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Hotel	34255
Resort	4553
Guest House / Bed & Breakfast	2319
Hostel	2075
Serviced Apartment	1180
Other values (17)	2545

Length

Max length	29
Median length	5
Mean length	6.861146
Min length	3

Characters and Unicode

Total characters	321973
Distinct characters	42
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Resort
2nd row	Hotel
3rd row	Hotel
4th row	Guest House / Bed & Breakfast
5th row	Hotel

Common Values

Value	Count	Frequency (%)
Hotel	34255	73.0%
Resort	4553	9.7%
Guest House / Bed & Breakfast	2319	4.9%
Hostel	2075	4.4%
Serviced Apartment	1180	2.5%
Apartment	938	2.0%
Motel	454	1.0%
Resort Villa	278	0.6%
Capsule Hotel	270	0.6%
Ryokan	238	0.5%
Other values (12)	367	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hotel	34533	57.1%
resort	4831	8.0%
	4680	7.7%
guest	2319	3.8%
house	2319	3.8%
bed	2319	3.8%
breakfast	2319	3.8%
apartment	2118	3.5%
hostel	2075	3.4%
serviced	1180	2.0%
Other values (19)	1775	2.9%

Most occurring characters

Value	Count	Frequency (%)
e	56086	17.4%
t	50837	15.8%
o	44685	13.9%
H	39053	12.1%
l	38123	11.8%
s	14139	4.4%
	13541	4.2%
r	10616	3.3%
a	7968	2.5%
R	5069	1.6%
Other values (32)	41856	13.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	247574	76.9%
Uppercase Letter	56178	17.4%
Space Separator	13541	4.2%
Other Punctuation	4680	1.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	56086	22.7%
t	50837	20.5%
o	44685	18.0%
l	38123	15.4%
s	14139	5.7%
r	10616	4.3%
a	7968	3.2%
u	5006	2.0%
d	3539	1.4%
k	2631	1.1%
Other values (11)	13944	5.6%

Uppercase Letter

Value	Count	Frequency (%)
H	39053	69.5%
R	5069	9.0%
B	4736	8.4%
G	2319	4.1%
A	2118	3.8%
S	1180	2.1%
M	454	0.8%
V	330	0.6%
C	313	0.6%
N	195	0.3%
Other values (8)	411	0.7%

Other Punctuation

Value	Count	Frequency (%)
/	2361	50.4%
&	2319	49.6%

Space Separator

Value	Count	Frequency (%)
	13541	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	303752	94.3%
Common	18221	5.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	56086	18.5%
t	50837	16.7%
o	44685	14.7%
H	39053	12.9%
l	38123	12.6%
s	14139	4.7%
r	10616	3.5%
a	7968	2.6%
R	5069	1.7%
u	5006	1.6%
Other values (29)	32170	10.6%

Common

Value	Count	Frequency (%)
	13541	74.3%
/	2361	13.0%
&	2319	12.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	321973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	56086	17.4%
t	50837	15.8%
o	44685	13.9%
H	39053	12.1%
l	38123	11.8%
s	14139	4.4%
	13541	4.2%
r	10616	3.3%
a	7968	2.5%
R	5069	1.6%
Other values (32)	41856	13.0%

charge_option
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Pay Now	35335
Pay Later	11567
Pay at Check-in	25

Length

Max length	15
Median length	7
Mean length	7.4972404
Min length	7

Characters and Unicode

Total characters	351823
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pay Now
2nd row	Pay Now
3rd row	Pay Now
4th row	Pay Now
5th row	Pay Later

Common Values

Value	Count	Frequency (%)
Pay Now	35335	75.3%
Pay Later	11567	24.6%
Pay at Check-in	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pay	46927	50.0%
now	35335	37.6%
later	11567	12.3%
at	25	< 0.1%
check-in	25	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	58519	16.6%
	46952	13.3%
P	46927	13.3%
y	46927	13.3%
N	35335	10.0%
o	35335	10.0%
w	35335	10.0%
t	11592	3.3%
e	11592	3.3%
L	11567	3.3%
Other values (8)	11742	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	210992	60.0%
Uppercase Letter	93854	26.7%
Space Separator	46952	13.3%
Dash Punctuation	25	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	58519	27.7%
y	46927	22.2%
o	35335	16.7%
w	35335	16.7%
t	11592	5.5%
e	11592	5.5%
r	11567	5.5%
h	25	< 0.1%
c	25	< 0.1%
k	25	< 0.1%
Other values (2)	50	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	46927	50.0%
N	35335	37.6%
L	11567	12.3%
C	25	< 0.1%

Space Separator

Value	Count	Frequency (%)
	46952	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	25	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	304846	86.6%
Common	46977	13.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	58519	19.2%
P	46927	15.4%
y	46927	15.4%
N	35335	11.6%
o	35335	11.6%
w	35335	11.6%
t	11592	3.8%
e	11592	3.8%
L	11567	3.8%
r	11567	3.8%
Other values (6)	150	< 0.1%

Common

Value	Count	Frequency (%)
	46952	99.9%
-	25	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	351823	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	58519	16.6%
	46952	13.3%
P	46927	13.3%
y	46927	13.3%
N	35335	10.0%
o	35335	10.0%
w	35335	10.0%
t	11592	3.3%
e	11592	3.3%
L	11567	3.3%
Other values (8)	11742	3.3%

h_customer_id
Real number (ℝ)

Distinct	24392
Distinct (%)	52.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5089212 × 10¹⁸

Minimum	-9.096408 × 10¹⁸
Maximum	9.2233353 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	445
Negative (%)	0.9%
Memory size	366.7 KiB

Quantile statistics

Minimum	-9.096408 × 10¹⁸
5-th percentile	4.0199151 × 10¹⁷
Q1	2.2306526 × 10¹⁸
median	4.5488106 × 10¹⁸
Q3	6.8535869 × 10¹⁸
95-th percentile	8.7526647 × 10¹⁸
Maximum	9.2233353 × 10¹⁸
Range	-1.2700075 × 10¹⁷
Interquartile range (IQR)	4.6229344 × 10¹⁸

Descriptive statistics

Standard deviation	2.8042853 × 10¹⁸
Coefficient of variation (CV)	0.62194152
Kurtosis	0.11193679
Mean	4.5089212 × 10¹⁸
Median Absolute Deviation (MAD)	2.311866 × 10¹⁸
Skewness	-0.33204114
Sum	5.9925552 × 10¹⁸
Variance	7.8640161 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.476281626 × 10¹⁸	258	0.5%
9.896276996 × 10¹⁷	124	0.3%
3.403039646 × 10¹⁸	113	0.2%
6.17110326 × 10¹⁸	108	0.2%
2.260038697 × 10¹⁸	94	0.2%
2.84968879 × 10¹⁸	65	0.1%
6.096800854 × 10¹⁸	62	0.1%
7.537464804 × 10¹⁸	51	0.1%
6.357426652 × 10¹⁷	49	0.1%
7.190936377 × 10¹⁸	49	0.1%
Other values (24382)	45954	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.096407971 × 10¹⁸	1	< 0.1%
-9.095945867 × 10¹⁸	1	< 0.1%
-9.077138756 × 10¹⁸	3	< 0.1%
-9.063637105 × 10¹⁸	1	< 0.1%
-9.029931 × 10¹⁸	2	< 0.1%
-9.020452036 × 10¹⁸	6	< 0.1%
-8.961035497 × 10¹⁸	1	< 0.1%
-8.931780579 × 10¹⁸	2	< 0.1%
-8.908509556 × 10¹⁸	1	< 0.1%
-8.896314417 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
9.223335348 × 10¹⁸	1	< 0.1%
9.223298569 × 10¹⁸	4	< 0.1%
9.223219011 × 10¹⁸	1	< 0.1%
9.223204826 × 10¹⁸	1	< 0.1%
9.222879283 × 10¹⁸	1	< 0.1%
9.222675043 × 10¹⁸	2	< 0.1%
9.222136928 × 10¹⁸	1	< 0.1%
9.221635623 × 10¹⁸	1	< 0.1%
9.221401145 × 10¹⁸	8	< 0.1%
9.221262823 × 10¹⁸	1	< 0.1%

customer_nationality
Text

Distinct	136
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	21
Mean length	8.8196134
Min length	4

Characters and Unicode

Total characters	413878
Distinct characters	55
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6364	10.0%
korea	6227	9.8%
malaysia	6068	9.5%
taiwan	5059	8.0%
thailand	3409	5.4%
united	3078	4.8%
china	2669	4.2%
japan	2330	3.7%
hong	2241	3.5%
kong	2241	3.5%
Other values (151)	23912	37.6%

Most occurring characters

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (45)	149596	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	322079	77.8%
Uppercase Letter	75123	18.2%
Space Separator	16671	4.0%
Dash Punctuation	3	< 0.1%
Other Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	68559	21.3%
i	37749	11.7%
n	33947	10.5%
o	24183	7.5%
e	22684	7.0%
t	16690	5.2%
r	14661	4.6%
s	14628	4.5%
h	14514	4.5%
l	14009	4.3%
Other values (16)	60455	18.8%

Uppercase Letter

Value	Count	Frequency (%)
K	11677	15.5%
S	11036	14.7%
T	8579	11.4%
N	7190	9.6%
M	6499	8.7%
U	5347	7.1%
A	4143	5.5%
C	3152	4.2%
I	3066	4.1%
O	2363	3.1%
Other values (15)	12071	16.1%

Space Separator

Value	Count	Frequency (%)
	16667	> 99.9%
	4	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	397202	96.0%
Common	16676	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	68559	17.3%
i	37749	9.5%
n	33947	8.5%
o	24183	6.1%
e	22684	5.7%
t	16690	4.2%
r	14661	3.7%
s	14628	3.7%
h	14514	3.7%
l	14009	3.5%
Other values (41)	135578	34.1%

Common

Value	Count	Frequency (%)
	16667	99.9%
	4	< 0.1%
-	3	< 0.1%
'	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413874	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (44)	149592	36.1%

None

Value	Count	Frequency (%)
	4	100.0%

guest_is_not_the_customer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	36872
1	10055

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring characters

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

guest_nationality_country_name
Text

Distinct	144
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	26
Mean length	8.4160718
Min length	4

Characters and Unicode

Total characters	394941
Distinct characters	57
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6765	11.2%
korea	6634	11.0%
malaysia	6163	10.2%
taiwan	5347	8.9%
thailand	3514	5.8%
united	3211	5.3%
china	3075	5.1%
japan	2469	4.1%
hong	2287	3.8%
kong	2287	3.8%
Other values (162)	18660	30.9%

Most occurring characters

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (47)	130879	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	321012	81.3%
Uppercase Letter	60439	15.3%
Space Separator	13485	3.4%
Other Punctuation	3	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	69572	21.7%
i	37621	11.7%
n	35710	11.1%
o	23356	7.3%
e	21766	6.8%
t	17532	5.5%
h	15545	4.8%
s	15086	4.7%
l	14393	4.5%
r	13380	4.2%
Other values (16)	57051	17.8%

Uppercase Letter

Value	Count	Frequency (%)
S	11588	19.2%
K	9947	16.5%
T	8986	14.9%
M	6640	11.0%
C	3587	5.9%
U	3249	5.4%
I	3217	5.3%
J	2481	4.1%
H	2298	3.8%
A	2284	3.8%
Other values (15)	6162	10.2%

Space Separator

Value	Count	Frequency (%)
	13481	> 99.9%
	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	2	66.7%
&	1	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	381451	96.6%
Common	13490	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	69572	18.2%
i	37621	9.9%
n	35710	9.4%
o	23356	6.1%
e	21766	5.7%
t	17532	4.6%
h	15545	4.1%
s	15086	4.0%
l	14393	3.8%
r	13380	3.5%
Other values (41)	117490	30.8%

Common

Value	Count	Frequency (%)
	13481	99.9%
	4	< 0.1%
'	2	< 0.1%
&	1	< 0.1%
(	1	< 0.1%
)	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	394937	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (46)	130875	33.1%

None

Value	Count	Frequency (%)
	4	100.0%

no_of_adults
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3475611

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	30
Range	29
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3241378
Coefficient of variation (CV)	0.56404829
Kurtosis	33.488263
Mean	2.3475611
Median Absolute Deviation (MAD)	0
Skewness	4.2137414
Sum	110164
Variance	1.753341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2	32070	68.3%
1	5481	11.7%
4	4492	9.6%
3	2905	6.2%
6	926	2.0%
5	378	0.8%
8	301	0.6%
10	101	0.2%
7	81	0.2%
12	67	0.1%
Other values (11)	125	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5481	11.7%
2	32070	68.3%
3	2905	6.2%
4	4492	9.6%
5	378	0.8%
6	926	2.0%
7	81	0.2%
8	301	0.6%
9	49	0.1%
10	101	0.2%

Value	Count	Frequency (%)
30	1	< 0.1%
27	2	< 0.1%
20	1	< 0.1%
18	18	< 0.1%
17	2	< 0.1%
16	16	< 0.1%
15	4	< 0.1%
14	16	< 0.1%
13	3	< 0.1%
12	67	0.1%

no_of_children
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14814499

Minimum	0
Maximum	10
Zeros	42690
Zeros (%)	91.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.52912642
Coefficient of variation (CV)	3.5716795
Kurtosis	25.197554
Mean	0.14814499
Median Absolute Deviation (MAD)	0
Skewness	4.4201626
Sum	6952
Variance	0.27997477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
10	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
8	1	< 0.1%
7	2	< 0.1%
6	12	< 0.1%
5	18	< 0.1%
4	109	0.2%
3	251	0.5%
2	1726	3.7%
1	2117	4.5%
0	42690	91.0%

no_of_extra_bed
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	46416
1	483
2	22
3	5
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

no_of_room
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.140303

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.51904538
Coefficient of variation (CV)	0.45518197
Kurtosis	52.885359
Mean	1.140303
Median Absolute Deviation (MAD)	0
Skewness	5.9691302
Sum	53511
Variance	0.26940811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
9	20	< 0.1%
7	16	< 0.1%
8	12	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
7	16	< 0.1%
8	12	< 0.1%
9	20	< 0.1%

Value	Count	Frequency (%)
9	20	< 0.1%
8	12	< 0.1%
7	16	< 0.1%
6	32	0.1%
5	106	0.2%
4	244	0.5%
3	751	1.6%
2	3426	7.3%
1	42320	90.2%

origin_country_code
Text

Distinct	141
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	366.7 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	93850
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	< 0.1%

Sample

1st row	CN
2nd row	JP
3rd row	TW
4th row	TR
5th row	KR

Value	Count	Frequency (%)
kr	6298	13.4%
my	6185	13.2%
tw	5255	11.2%
th	4308	9.2%
jp	2530	5.4%
cn	2494	5.3%
hk	2424	5.2%
id	2263	4.8%
us	1960	4.2%
sg	1926	4.1%
Other values (131)	11282	24.0%

Most occurring characters

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.5%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (17)	25760	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	93784	99.9%
Decimal Number	66	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.6%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (16)	25694	27.4%

Decimal Number

Value	Count	Frequency (%)
1	66	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	99.9%
Common	66	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.6%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (16)	25694	27.4%

Common

Value	Count	Frequency (%)
1	66	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.5%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (17)	25760	27.4%

language
Categorical

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

English	17238
Korean	6684
T. Chinese / Taiwan	5776
S.Chinese / Mainland	3217
Japanese	2436
Other values (44)	11576

Length

Max length	24
Median length	22
Mean length	10.479511
Min length	4

Characters and Unicode

Total characters	491772
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	S.Chinese / Mainland
2nd row	Japanese
3rd row	T. Chinese / Taiwan
4th row	Turkish
5th row	Korean

Common Values

Value	Count	Frequency (%)
English	17238	36.7%
Korean	6684	14.2%
T. Chinese / Taiwan	5776	12.3%
S.Chinese / Mainland	3217	6.9%
Japanese	2436	5.2%
Thai	2399	5.1%
T.Chinese / Hongkong	1929	4.1%
English / United Kingdom	1293	2.8%
Indonesian	765	1.6%
Vietnamese	636	1.4%
Other values (39)	4554	9.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
english	19789	24.4%
	13516	16.7%
korean	6684	8.2%
t	5776	7.1%
chinese	5776	7.1%
taiwan	5776	7.1%
s.chinese	3217	4.0%
mainland	3217	4.0%
japanese	2436	3.0%
thai	2399	3.0%
Other values (46)	12465	15.4%

Most occurring characters

Value	Count	Frequency (%)
n	64199	13.1%
i	48835	9.9%
e	39552	8.0%
a	38076	7.7%
s	36138	7.3%
h	34355	7.0%
	34124	6.9%
g	25524	5.2%
l	24076	4.9%
E	19790	4.0%
Other values (39)	127103	25.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	360455	73.3%
Uppercase Letter	72718	14.8%
Space Separator	34124	6.9%
Other Punctuation	24438	5.0%
Dash Punctuation	37	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	64199	17.8%
i	48835	13.5%
e	39552	11.0%
a	38076	10.6%
s	36138	10.0%
h	34355	9.5%
g	25524	7.1%
l	24076	6.7%
o	13257	3.7%
r	9563	2.7%
Other values (14)	26880	7.5%

Uppercase Letter

Value	Count	Frequency (%)
E	19790	27.2%
T	15945	21.9%
C	11081	15.2%
K	7977	11.0%
S	3992	5.5%
M	3495	4.8%
J	2436	3.3%
H	2093	2.9%
U	1297	1.8%
I	1140	1.6%
Other values (11)	3472	4.8%

Other Punctuation

Value	Count	Frequency (%)
/	13516	55.3%
.	10922	44.7%

Space Separator

Value	Count	Frequency (%)
	34124	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	37	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	433173	88.1%
Common	58599	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	64199	14.8%
i	48835	11.3%
e	39552	9.1%
a	38076	8.8%
s	36138	8.3%
h	34355	7.9%
g	25524	5.9%
l	24076	5.6%
E	19790	4.6%
T	15945	3.7%
Other values (35)	86683	20.0%

Common

Value	Count	Frequency (%)
	34124	58.2%
/	13516	23.1%
.	10922	18.6%
-	37	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	491772	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	64199	13.1%
i	48835	9.9%
e	39552	8.0%
a	38076	7.7%
s	36138	7.3%
h	34355	7.0%
	34124	6.9%
g	25524	5.2%
l	24076	4.9%
E	19790	4.0%
Other values (39)	127103	25.8%

original_selling_amount
Real number (ℝ)

Distinct	26481
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	219.59182

Minimum	2.1
Maximum	49566.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	2.1
5-th percentile	17.7
Q1	50.585
median	107.78
Q3	243.01
95-th percentile	750.268
Maximum	49566.16
Range	49564.06
Interquartile range (IQR)	192.425

Descriptive statistics

Standard deviation	439.9447
Coefficient of variation (CV)	2.0034658
Kurtosis	3515.9943
Mean	219.59182
Median Absolute Deviation (MAD)	72.27
Skewness	36.550096
Sum	10304785
Variance	193551.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.63	14	< 0.1%
15	12	< 0.1%
37.05	12	< 0.1%
22	11	< 0.1%
45	11	< 0.1%
19.56	11	< 0.1%
222.94	10	< 0.1%
28.46	10	< 0.1%
30	10	< 0.1%
16.86	10	< 0.1%
Other values (26471)	46816	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.1	1	< 0.1%
2.27	1	< 0.1%
2.31	1	< 0.1%
2.5	1	< 0.1%
2.59	1	< 0.1%
2.64	1	< 0.1%
2.76	1	< 0.1%
2.8	1	< 0.1%
2.82	1	< 0.1%
2.9	1	< 0.1%

Value	Count	Frequency (%)
49566.16	1	< 0.1%
17942.82	1	< 0.1%
15430.5	1	< 0.1%
13015.52	1	< 0.1%
11672.15	1	< 0.1%
9562.86	1	< 0.1%
9074.52	1	< 0.1%
9065.76	1	< 0.1%
8024.56	1	< 0.1%
7437.78	1	< 0.1%

original_payment_method
Categorical

Distinct	36
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Visa	23088
MasterCard	13875
UNKNOWN	3210
American Express	2198
JCB	1124
Other values (31)	3432

Length

Max length	21
Median length	20
Mean length	6.8831163
Min length	3

Characters and Unicode

Total characters	323004
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Alipay
2nd row	American Express
3rd row	Visa
4th row	MasterCard
5th row	Visa

Common Values

Value	Count	Frequency (%)
Visa	23088	49.2%
MasterCard	13875	29.6%
UNKNOWN	3210	6.8%
American Express	2198	4.7%
JCB	1124	2.4%
Alipay	945	2.0%
PayPal	557	1.2%
MayBank2U	430	0.9%
UnionPay - Creditcard	292	0.6%
K PLUS	206	0.4%
Other values (26)	1002	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
visa	23088	45.5%
mastercard	13875	27.3%
unknown	3210	6.3%
american	2198	4.3%
express	2198	4.3%
jcb	1124	2.2%
alipay	945	1.9%
paypal	557	1.1%
maybank2u	430	0.8%
unionpay	339	0.7%
Other values (43)	2784	5.5%

Most occurring characters

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	228931	70.9%
Uppercase Letter	89464	27.7%
Space Separator	3821	1.2%
Decimal Number	449	0.1%
Dash Punctuation	339	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	57861	25.3%
s	41874	18.3%
r	32986	14.4%
i	27345	11.9%
e	19220	8.4%
t	14581	6.4%
d	14574	6.4%
n	3570	1.6%
p	3303	1.4%
c	2737	1.2%
Other values (13)	10880	4.8%

Uppercase Letter

Value	Count	Frequency (%)
V	23088	25.8%
C	15988	17.9%
M	14788	16.5%
N	9652	10.8%
U	4185	4.7%
K	3449	3.9%
W	3411	3.8%
A	3382	3.8%
O	3222	3.6%
E	2248	2.5%
Other values (12)	6051	6.8%

Decimal Number

Value	Count	Frequency (%)
2	430	95.8%
7	19	4.2%

Space Separator

Value	Count	Frequency (%)
	3821	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	339	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	318395	98.6%
Common	4609	1.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	57861	18.2%
s	41874	13.2%
r	32986	10.4%
i	27345	8.6%
V	23088	7.3%
e	19220	6.0%
C	15988	5.0%
M	14788	4.6%
t	14581	4.6%
d	14574	4.6%
Other values (35)	56090	17.6%

Common

Value	Count	Frequency (%)
	3821	82.9%
2	430	9.3%
-	339	7.4%
7	19	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	323004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

original_payment_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Credit Card	46132
Invoice	612
Gift Card	183

Length

Max length	11
Median length	11
Mean length	10.940035
Min length	7

Characters and Unicode

Total characters	513383
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Credit Card
2nd row	Credit Card
3rd row	Credit Card
4th row	Credit Card
5th row	Credit Card

Common Values

Value	Count	Frequency (%)
Credit Card	46132	98.3%
Invoice	612	1.3%
Gift Card	183	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	46315	49.7%
credit	46132	49.5%
invoice	612	0.7%
gift	183	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	373826	72.8%
Uppercase Letter	93242	18.2%
Space Separator	46315	9.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	92447	24.7%
d	92447	24.7%
i	46927	12.6%
e	46744	12.5%
t	46315	12.4%
a	46315	12.4%
n	612	0.2%
v	612	0.2%
o	612	0.2%
c	612	0.2%

Uppercase Letter

Value	Count	Frequency (%)
C	92447	99.1%
I	612	0.7%
G	183	0.2%

Space Separator

Value	Count	Frequency (%)
	46315	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	467068	91.0%
Common	46315	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	92447	19.8%
r	92447	19.8%
d	92447	19.8%
i	46927	10.0%
e	46744	10.0%
t	46315	9.9%
a	46315	9.9%
I	612	0.1%
n	612	0.1%
v	612	0.1%
Other values (4)	1590	0.3%

Common

Value	Count	Frequency (%)
	46315	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	513383	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

original_payment_currency
Categorical

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

MYR	6088
KRW	5995
TWD	5300
USD	3685
THB	3604
Other values (45)	22255

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CNY
2nd row	JPY
3rd row	TWD
4th row	TRY
5th row	KRW

Common Values

Value	Count	Frequency (%)
MYR	6088	13.0%
KRW	5995	12.8%
TWD	5300	11.3%
USD	3685	7.9%
THB	3604	7.7%
CNY	2908	6.2%
HKD	2695	5.7%
JPY	2677	5.7%
SGD	1977	4.2%
IDR	1908	4.1%
Other values (40)	10090	21.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
myr	6088	13.0%
krw	5995	12.8%
twd	5300	11.3%
usd	3685	7.9%
thb	3604	7.7%
cny	2908	6.2%
hkd	2695	5.7%
jpy	2677	5.7%
sgd	1977	4.2%
idr	1908	4.1%
Other values (40)	10090	21.5%

Most occurring characters

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140781	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140781	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

is_user_logged_in
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	30549
False	16378

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	30549	65.1%
False	16378	34.9%

cancellation_policy_code
Text

Distinct	719
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	20
Median length	19
Mean length	9.8295864
Min length	4

Characters and Unicode

Total characters	461273
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	348 ?
Unique (%)	0.7%

Sample

1st row	1D1N_1N
2nd row	3D1N_1N
3rd row	1D1N_1N
4th row	365D100P_100P
5th row	3D100P_100P

Value	Count	Frequency (%)
365d100p_100p	12793	27.3%
1d1n_1n	7026	15.0%
3d1n_1n	2712	5.8%
1d100p	2008	4.3%
3d1n_100p	1984	4.2%
1d100p_100p	1361	2.9%
7d100p_100p	1258	2.7%
3d100p_100p	1220	2.6%
2d100p	1175	2.5%
3d100p	1125	2.4%
Other values (709)	14265	30.4%

Most occurring characters

Value	Count	Frequency (%)
0	116602	25.3%
1	98713	21.4%
P	58967	12.8%
D	48674	10.6%
_	41142	8.9%
N	30034	6.5%
3	22793	4.9%
5	16343	3.5%
6	13603	2.9%
2	4778	1.0%
Other values (8)	9624	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	280592	60.8%
Uppercase Letter	139539	30.3%
Connector Punctuation	41142	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	116602	41.6%
1	98713	35.2%
3	22793	8.1%
5	16343	5.8%
6	13603	4.8%
2	4778	1.7%
7	4537	1.6%
4	2485	0.9%
8	454	0.2%
9	284	0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	58967	42.3%
D	48674	34.9%
N	30034	21.5%
U	466	0.3%
K	466	0.3%
O	466	0.3%
W	466	0.3%

Connector Punctuation

Value	Count	Frequency (%)
_	41142	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	321734	69.7%
Latin	139539	30.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	116602	36.2%
1	98713	30.7%
_	41142	12.8%
3	22793	7.1%
5	16343	5.1%
6	13603	4.2%
2	4778	1.5%
7	4537	1.4%
4	2485	0.8%
8	454	0.1%

Latin

Value	Count	Frequency (%)
P	58967	42.3%
D	48674	34.9%
N	30034	21.5%
U	466	0.3%
K	466	0.3%
O	466	0.3%
W	466	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	461273	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	116602	25.3%
1	98713	21.4%
P	58967	12.8%
D	48674	10.6%
_	41142	8.9%
N	30034	6.5%
3	22793	4.9%
5	16343	3.5%
6	13603	2.9%
2	4778	1.0%
Other values (8)	9624	2.1%

is_first_booking
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	36484
True	10443

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	36484	77.7%
True	10443	22.3%

request_nonesmoke
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

1.0	19328
0.0	7569

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	19328	41.2%
0.0	7569	16.1%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	19328	71.9%
0.0	7569	28.1%

Most occurring characters

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	34466	64.1%
1	19328	35.9%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

request_latecheckin
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	26195
1.0	702

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	26195	55.8%
1.0	702	1.5%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	26195	97.4%
1.0	702	2.6%

Most occurring characters

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	53092	98.7%
1	702	1.3%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

request_highfloor
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	22844
1.0	4053

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	22844	48.7%
1.0	4053	8.6%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	22844	84.9%
1.0	4053	15.1%

Most occurring characters

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	49741	92.5%
1	4053	7.5%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

request_largebed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	16391
1.0	10506

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	1.0
3rd row	0.0
4th row	0.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	16391	34.9%
1.0	10506	22.4%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	16391	60.9%
1.0	10506	39.1%

Most occurring characters

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	43288	80.5%
1	10506	19.5%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

request_twinbeds
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	22624
1.0	4273

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	22624	48.2%
1.0	4273	9.1%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	22624	84.1%
1.0	4273	15.9%

Most occurring characters

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	49521	92.1%
1	4273	7.9%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

request_airport
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	26698
1.0	199

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	26698	56.9%
1.0	199	0.4%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	26698	99.3%
1.0	199	0.7%

Most occurring characters

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	53595	99.6%
1	199	0.4%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

request_earlycheckin
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	25996
1.0	901

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	25996	55.4%
1.0	901	1.9%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	25996	96.7%
1.0	901	3.3%

Most occurring characters

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	52893	98.3%
1	901	1.7%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

hotel_area_code
Real number (ℝ)

Distinct	5057
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3025.0395

Minimum	1
Maximum	5896
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	243
Q1	1477
median	3134
Q3	4572
95-th percentile	5602
Maximum	5896
Range	5895
Interquartile range (IQR)	3095

Descriptive statistics

Standard deviation	1733.8559
Coefficient of variation (CV)	0.573168
Kurtosis	-1.2487545
Mean	3025.0395
Median Absolute Deviation (MAD)	1549
Skewness	-0.11513251
Sum	1.4195603 × 10⁸
Variance	3006256.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3747	718	1.5%
1192	571	1.2%
643	419	0.9%
4463	404	0.9%
606	382	0.8%
104	372	0.8%
4364	342	0.7%
3156	335	0.7%
2553	322	0.7%
5891	302	0.6%
Other values (5047)	42760	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	7	< 0.1%
5	1	< 0.1%
6	5	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	7	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
5896	1	< 0.1%
5894	2	< 0.1%
5893	1	< 0.1%
5892	2	< 0.1%
5891	302	0.6%
5890	1	< 0.1%
5889	18	< 0.1%
5888	1	< 0.1%
5887	39	0.1%
5886	10	< 0.1%

hotel_brand_code
Real number (ℝ)

Distinct	850
Distinct (%)	7.0%
Missing	34699
Missing (%)	73.9%
Infinite	0
Infinite (%)	0.0%
Mean	479.07458

Minimum	0
Maximum	936
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	253
median	481
Q3	741
95-th percentile	914
Maximum	936
Range	936
Interquartile range (IQR)	488

Descriptive statistics

Standard deviation	277.61635
Coefficient of variation (CV)	0.57948461
Kurtosis	-1.1793446
Mean	479.07458
Median Absolute Deviation (MAD)	243
Skewness	-0.0051064914
Sum	5858124
Variance	77070.837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
777	293	0.6%
442	254	0.5%
51	222	0.5%
253	215	0.5%
593	205	0.4%
918	195	0.4%
520	176	0.4%
50	160	0.3%
789	157	0.3%
193	155	0.3%
Other values (840)	10196	21.7%
(Missing)	34699	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	3	< 0.1%
2	3	< 0.1%
3	35	0.1%
4	2	< 0.1%
6	13	< 0.1%
7	5	< 0.1%
8	3	< 0.1%
9	65	0.1%
10	28	0.1%

Value	Count	Frequency (%)
936	66	0.1%
935	11	< 0.1%
934	7	< 0.1%
933	58	0.1%
932	7	< 0.1%
931	28	0.1%
930	2	< 0.1%
929	1	< 0.1%
928	4	< 0.1%
927	2	< 0.1%

hotel_chain_code
Real number (ℝ)

Distinct	610
Distinct (%)	4.8%
Missing	34343
Missing (%)	73.2%
Infinite	0
Infinite (%)	0.0%
Mean	357.64781

Minimum	0
Maximum	680
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	28
Q1	181
median	355
Q3	575
95-th percentile	672
Maximum	680
Range	680
Interquartile range (IQR)	394

Descriptive statistics

Standard deviation	208.81905
Coefficient of variation (CV)	0.58386783
Kurtosis	-1.3361399
Mean	357.64781
Median Absolute Deviation (MAD)	209
Skewness	-0.058302719
Sum	4500640
Variance	43605.395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	696	1.5%
296	607	1.3%
675	383	0.8%
55	363	0.8%
181	340	0.7%
386	279	0.6%
537	249	0.5%
587	232	0.5%
217	222	0.5%
583	214	0.5%
Other values (600)	8999	19.2%
(Missing)	34343	73.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
1	50	0.1%
2	39	0.1%
3	1	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
7	3	< 0.1%
8	5	< 0.1%
9	1	< 0.1%
10	50	0.1%

Value	Count	Frequency (%)
680	3	< 0.1%
679	52	0.1%
678	117	0.2%
677	13	< 0.1%
676	2	< 0.1%
675	383	0.8%
674	15	< 0.1%
673	27	0.1%
672	26	0.1%
671	2	< 0.1%

hotel_city_code
Real number (ℝ)

Distinct	2402
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1498.0466

Minimum	0
Maximum	2808
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	140
Q1	583
median	1572
Q3	2310
95-th percentile	2797
Maximum	2808
Range	2808
Interquartile range (IQR)	1727

Descriptive statistics

Standard deviation	909.02087
Coefficient of variation (CV)	0.60680414
Kurtosis	-1.4051834
Mean	1498.0466
Median Absolute Deviation (MAD)	875
Skewness	-0.16917617
Sum	70298832
Variance	826318.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2477	2525	5.4%
2797	1883	4.0%
1403	1794	3.8%
142	1295	2.8%
162	1163	2.5%
2249	1124	2.4%
437	1059	2.3%
2799	987	2.1%
1816	881	1.9%
2310	767	1.6%
Other values (2392)	33449	71.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
3	10	< 0.1%
4	2	< 0.1%
5	20	< 0.1%
6	3	< 0.1%
8	29	0.1%
9	1	< 0.1%
10	2	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
2808	2	< 0.1%
2807	3	< 0.1%
2806	1	< 0.1%
2805	1	< 0.1%
2804	2	< 0.1%
2803	1	< 0.1%
2802	1	< 0.1%
2800	10	< 0.1%
2799	987	2.1%
2797	1883	4.0%

cancellation_datetime
Date

Distinct	347
Distinct (%)	2.7%
Missing	34250
Missing (%)	73.0%
Memory size	366.7 KiB

Minimum	2017-08-12 00:00:00
Maximum	2019-03-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Auto

Heatmap
Table

	h_booking_id	hotel_id	hotel_star_rating	h_customer_id	no_of_adults	no_of_children	no_of_room	original_selling_amount	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	accommadation_type_name	charge_option	guest_is_not_the_customer	no_of_extra_bed	language	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin
h_booking_id	1.000	-0.003	0.004	0.004	0.003	0.001	0.007	0.006	-0.000	-0.013	-0.010	0.002	0.000	0.000	0.008	0.003	0.000	0.004	0.000	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
hotel_id	-0.003	1.000	-0.171	-0.010	-0.022	-0.048	-0.031	-0.110	0.006	-0.036	0.053	0.026	0.087	0.115	0.041	0.028	0.056	0.066	0.062	0.067	0.058	0.022	0.035	0.019	0.036	0.025	0.024	0.000	0.017
hotel_star_rating	0.004	-0.171	1.000	0.017	0.094	0.078	0.036	0.445	-0.002	-0.017	-0.097	-0.024	0.195	0.068	0.048	0.021	0.081	0.100	0.055	0.108	0.029	0.038	0.039	0.021	0.162	0.097	0.078	0.032	0.050
h_customer_id	0.004	-0.010	0.017	1.000	0.018	0.010	0.006	0.015	-0.002	0.009	-0.025	-0.009	0.027	0.020	0.023	0.000	0.037	0.030	0.063	0.057	0.032	0.015	0.017	0.043	0.007	0.029	0.024	0.000	0.000
no_of_adults	0.003	-0.022	0.094	0.018	1.000	0.047	0.529	0.258	0.012	-0.025	-0.004	0.013	0.057	0.042	0.032	0.106	0.029	0.000	0.019	0.036	0.018	0.008	0.029	0.000	0.007	0.099	0.080	0.033	0.000
no_of_children	0.001	-0.048	0.078	0.010	0.047	1.000	0.064	0.161	-0.018	-0.036	-0.014	0.017	0.023	0.064	0.020	0.037	0.030	0.025	0.007	0.044	0.006	0.038	0.000	0.011	0.010	0.067	0.025	0.020	0.031
no_of_room	0.007	-0.031	0.036	0.006	0.529	0.064	1.000	0.219	-0.005	0.005	-0.001	-0.011	0.019	0.034	0.044	0.102	0.025	0.008	0.010	0.035	0.020	0.008	0.028	0.000	0.004	0.052	0.068	0.027	0.000
original_selling_amount	0.006	-0.110	0.445	0.015	0.258	0.161	0.219	1.000	-0.032	-0.010	-0.053	-0.042	0.000	0.006	0.013	0.000	0.030	0.000	0.000	0.034	0.000	0.000	0.004	0.000	0.000	0.000	0.000	0.022	0.000
hotel_area_code	-0.000	0.006	-0.002	-0.002	0.012	-0.018	-0.005	-0.032	1.000	0.044	0.020	0.013	0.052	0.030	0.050	0.011	0.060	0.037	0.100	0.078	0.035	0.024	0.033	0.024	0.041	0.011	0.019	0.028	0.000
hotel_brand_code	-0.013	-0.036	-0.017	0.009	-0.025	-0.036	0.005	-0.010	0.044	1.000	-0.050	-0.011	0.110	0.066	0.033	0.014	0.077	0.058	0.021	0.099	0.031	0.043	0.036	0.023	0.040	0.012	0.016	0.012	0.025
hotel_chain_code	-0.010	0.053	-0.097	-0.025	-0.004	-0.014	-0.001	-0.053	0.020	-0.050	1.000	-0.013	0.098	0.087	0.041	0.017	0.093	0.062	0.018	0.117	0.078	0.081	0.000	0.029	0.033	0.035	0.022	0.016	0.056
hotel_city_code	0.002	0.026	-0.024	-0.009	0.013	0.017	-0.011	-0.042	0.013	-0.011	-0.013	1.000	0.093	0.052	0.061	0.015	0.128	0.055	0.095	0.172	0.040	0.053	0.032	0.028	0.048	0.029	0.002	0.024	0.038
accommadation_type_name	0.000	0.087	0.195	0.027	0.057	0.023	0.019	0.000	0.052	0.110	0.098	0.093	1.000	0.044	0.054	0.028	0.055	0.042	0.028	0.062	0.025	0.042	0.060	0.000	0.111	0.105	0.074	0.031	0.031
charge_option	0.000	0.115	0.068	0.020	0.042	0.064	0.034	0.006	0.030	0.066	0.087	0.052	0.044	1.000	0.044	0.024	0.155	0.166	0.048	0.173	0.096	0.038	0.022	0.023	0.057	0.053	0.033	0.044	0.000
guest_is_not_the_customer	0.008	0.041	0.048	0.023	0.032	0.020	0.044	0.013	0.050	0.033	0.041	0.061	0.054	0.044	1.000	0.014	0.161	0.079	0.082	0.199	0.046	0.162	0.014	0.019	0.021	0.000	0.042	0.009	0.028
no_of_extra_bed	0.003	0.028	0.021	0.000	0.106	0.037	0.102	0.000	0.011	0.014	0.017	0.015	0.028	0.024	0.014	1.000	0.031	0.000	0.000	0.047	0.000	0.013	0.014	0.017	0.000	0.031	0.031	0.044	0.013
language	0.000	0.056	0.081	0.037	0.029	0.030	0.025	0.030	0.060	0.077	0.093	0.128	0.055	0.155	0.161	0.031	1.000	0.161	0.299	0.535	0.203	0.192	0.079	0.089	0.147	0.128	0.099	0.061	0.102
original_payment_method	0.004	0.066	0.100	0.030	0.000	0.025	0.008	0.000	0.037	0.058	0.062	0.055	0.042	0.166	0.079	0.000	0.161	1.000	0.341	0.163	0.123	0.096	0.048	0.033	0.093	0.094	0.055	0.000	0.054
original_payment_type	0.000	0.062	0.055	0.063	0.019	0.007	0.010	0.000	0.100	0.021	0.018	0.095	0.028	0.048	0.082	0.000	0.299	0.341	1.000	0.316	0.163	0.053	0.019	0.000	0.015	0.017	0.000	0.000	0.000
original_payment_currency	0.009	0.067	0.108	0.057	0.036	0.044	0.035	0.034	0.078	0.099	0.117	0.172	0.062	0.173	0.199	0.047	0.535	0.163	0.316	1.000	0.199	0.218	0.074	0.081	0.192	0.150	0.104	0.125	0.105
is_user_logged_in	0.000	0.058	0.029	0.032	0.018	0.006	0.020	0.000	0.035	0.031	0.078	0.040	0.025	0.096	0.046	0.000	0.203	0.123	0.163	0.199	1.000	0.479	0.019	0.050	0.119	0.022	0.000	0.000	0.056
is_first_booking	0.000	0.022	0.038	0.015	0.008	0.038	0.008	0.000	0.024	0.043	0.081	0.053	0.042	0.038	0.162	0.013	0.192	0.096	0.053	0.218	0.479	1.000	0.032	0.043	0.086	0.000	0.000	0.025	0.046
request_nonesmoke	0.000	0.035	0.039	0.017	0.029	0.000	0.028	0.004	0.033	0.036	0.000	0.032	0.060	0.022	0.014	0.014	0.079	0.048	0.019	0.074	0.019	0.032	1.000	0.043	0.038	0.091	0.066	0.014	0.038
request_latecheckin	0.000	0.019	0.021	0.043	0.000	0.011	0.000	0.000	0.024	0.023	0.029	0.028	0.000	0.023	0.019	0.017	0.089	0.033	0.000	0.081	0.050	0.043	0.043	1.000	0.112	0.039	0.004	0.011	0.029
request_highfloor	0.000	0.036	0.162	0.007	0.007	0.010	0.004	0.000	0.041	0.040	0.033	0.048	0.111	0.057	0.021	0.000	0.147	0.093	0.015	0.192	0.119	0.086	0.038	0.112	1.000	0.152	0.045	0.030	0.171
request_largebed	0.000	0.025	0.097	0.029	0.099	0.067	0.052	0.000	0.011	0.012	0.035	0.029	0.105	0.053	0.000	0.031	0.128	0.094	0.017	0.150	0.022	0.000	0.091	0.039	0.152	1.000	0.348	0.016	0.038
request_twinbeds	0.000	0.024	0.078	0.024	0.080	0.025	0.068	0.000	0.019	0.016	0.022	0.002	0.074	0.033	0.042	0.031	0.099	0.055	0.000	0.104	0.000	0.000	0.066	0.004	0.045	0.348	1.000	0.000	0.002
request_airport	0.000	0.000	0.032	0.000	0.033	0.020	0.027	0.022	0.028	0.012	0.016	0.024	0.031	0.044	0.009	0.044	0.061	0.000	0.000	0.125	0.000	0.025	0.014	0.011	0.030	0.016	0.000	1.000	0.014
request_earlycheckin	0.000	0.017	0.050	0.000	0.000	0.031	0.000	0.000	0.000	0.025	0.056	0.038	0.031	0.000	0.028	0.013	0.102	0.054	0.000	0.105	0.056	0.046	0.038	0.029	0.171	0.038	0.002	0.014	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	charge_option	h_customer_id	customer_nationality	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	cancellation_datetime
0	7861445258918608962	2017-10-21 19:26:00	2018-07-31 00:00:00	2018-08-01 00:00:00	88838	AU	2012-10-04 10:03:00	4.0	Resort	Pay Now	5310397980746630019	China	China	12	2	CN	S.Chinese / Mainland	436.52	Alipay	Credit Card	CNY	True	1D1N_1N	False	1.0	0.0	0.0	0.0	0.0	0.0	0.0	5832	50.0	675.0	461	NaN
1	-3175925110616170919	2018-08-10 15:40:00	2018-08-10 00:00:00	2018-08-11 00:00:00	51920	JP	2012-10-01 10:03:00	3.0	Hotel	Pay Now	3627650004083420090	Japan	Japan	1	1	JP	Japanese	54.01	American Express	Credit Card	JPY	True	3D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	643	296.0	191.0	2249	NaN
2	-5166200042028380517	2018-09-14 21:56:00	2018-09-14 00:00:00	2018-09-15 00:00:00	90189	TW	2014-06-12 08:05:00	4.0	Hotel	Pay Now	6891579066921110017	Taiwan	Taiwan	2	1	TW	T. Chinese / Taiwan	99.18	Visa	Credit Card	TWD	True	1D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2900	NaN	NaN	892	NaN
3	6165211278500849566	2018-09-13 13:34:00	2018-09-13 00:00:00	2018-09-14 00:00:00	236389	TR	2010-08-31 07:16:00	0.0	Guest House / Bed & Breakfast	Pay Now	5915665216707180023	Turkey	Turkey	1	1	TR	Turkish	19.36	MasterCard	Credit Card	TRY	False	365D100P_100P	False	0.0	0.0	0.0	1.0	0.0	0.0	0.0	3110	NaN	NaN	744	NaN
4	-1853092131420973567	2018-02-01 20:44:00	2018-08-31 00:00:00	2018-09-02 00:00:00	187085	JP	2010-07-01 07:38:00	3.5	Hotel	Pay Later	8271660960620410074	South Korea	South Korea	1	1	KR	Korean	175.52	Visa	Credit Card	KRW	True	3D100P_100P	False	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3760	453.0	359.0	2260	2018-02-02
5	8478973924173415354	2018-06-21 23:14:00	2018-07-15 00:00:00	2018-07-17 00:00:00	788472	TH	2015-01-15 15:54:00	3.0	Hotel	Pay Now	1760275406207060063	South Korea	South Korea	2	1	KR	Korean	68.38	UnionPay - Creditcard	Credit Card	KRW	False	365D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1709	NaN	NaN	1636	NaN
6	-1853437799368162580	2018-07-27 07:23:00	2018-08-19 00:00:00	2018-08-21 00:00:00	1634464	TH	2016-12-19 12:24:00	3.5	Hotel	Pay Later	4700808392292780093	South Korea	South Korea	1	1	KR	English	163.60	Visa	Credit Card	KRW	True	1D1N_100P	False	1.0	0.0	0.0	0.0	0.0	0.0	1.0	2964	442.0	600.0	2477	2018-08-17
7	259359728717957150	2018-07-24 19:59:00	2018-08-10 00:00:00	2018-08-13 00:00:00	3002333	TH	2017-11-11 20:57:00	2.0	Hotel	Pay Later	3622815626917240092	Thailand	Thailand	2	1	TH	Thai	48.54	Visa	Credit Card	THB	False	1D1N_1N	False	1.0	0.0	0.0	1.0	0.0	0.0	0.0	2964	NaN	NaN	2477	NaN
8	-1624588124260700023	2018-08-25 06:39:00	2018-09-15 00:00:00	2018-09-17 00:00:00	1160850	KR	2016-01-27 12:39:00	3.0	Hotel	Pay Now	3580464825046080007	South Korea	South Korea	3	1	KR	Korean	119.11	UnionPay - Creditcard	Credit Card	KRW	False	7D100P_100P	True	1.0	0.0	0.0	0.0	1.0	0.0	0.0	3901	NaN	NaN	2459	2018-08-25
9	8703485699898329335	2018-04-23 23:19:00	2018-08-18 00:00:00	2018-08-19 00:00:00	304893	FJ	2010-11-17 07:09:00	3.5	Hotel	Pay Now	2129668180375770076	China	China	2	1	CN	S.Chinese / Mainland	87.78	UNKNOWN	Invoice	CNY	False	7D50P_2D100P_100P	True	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4806	NaN	NaN	2745	NaN

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	charge_option	h_customer_id	customer_nationality	guest_is_not_the_customer	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	cancellation_datetime
46917	-3955370707847627756	2018-05-27 12:46:00	2018-07-05 00:00:00	2018-07-08 00:00:00	289317	HK	2011-10-26 16:50:00	1.0	Hostel	Pay Now	2223633554451910061	China	0	China	2	1	CN	S.Chinese / Mainland	116.77	WeChat	Credit Card	CNY	True	365D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5262	NaN	NaN	142	NaN
46918	-7280254002553494006	2018-03-21 18:23:00	2018-09-27 00:00:00	2018-09-28 00:00:00	196931	JP	2011-06-29 10:05:00	4.0	Hotel	Pay Later	3057302628167480032	South Korea	0	South Korea	1	1	KR	Korean	196.43	MasterCard	Credit Card	KRW	True	3D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2722	87.0	103.0	1335	2018-03-30
46919	8038861849194051967	2018-02-01 20:34:00	2018-08-31 00:00:00	2018-09-02 00:00:00	812762	JP	2015-03-11 14:43:00	3.0	Hotel	Pay Later	8271660960620410074	South Korea	0	South Korea	1	1	KR	Korean	132.78	Visa	Credit Card	KRW	False	28D100P_100P	True	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3760	NaN	NaN	2260	2018-02-02
46920	-5687848489097746853	2018-06-29 20:17:00	2018-08-03 00:00:00	2018-08-06 00:00:00	868632	JP	2015-02-26 16:35:00	1.0	Hostel	Pay Now	989627699560000000	South Korea	0	South Korea	1	1	KR	Korean	87.01	Visa	Credit Card	KRW	True	2D50P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3950	NaN	NaN	220	2018-07-03
46921	4805148141901219862	2018-06-22 06:21:00	2018-09-02 00:00:00	2018-09-04 00:00:00	3132844	KR	2017-11-06 16:47:00	3.0	Hotel	Pay Now	4543871625495590025	Taiwan	0	Taiwan	3	1	TW	T. Chinese / Taiwan	183.54	Visa	Credit Card	TWD	True	3D100P	False	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5242	NaN	NaN	731	NaN
46922	7859361556233200164	2018-09-15 22:29:00	2018-09-16 00:00:00	2018-09-17 00:00:00	2504240	JP	2017-07-08 14:23:00	3.0	Ryokan	Pay Now	2856938804428580064	Japan	0	Japan	2	1	JP	Japanese	142.68	UNKNOWN	Credit Card	JPY	False	2D100P	True	1.0	0.0	0.0	1.0	0.0	0.0	0.0	185	NaN	NaN	2039	NaN
46923	2778941468684758600	2018-09-22 22:42:00	2018-09-27 00:00:00	2018-09-29 00:00:00	2613173	JP	2017-08-15 07:07:00	2.0	Guest House / Bed & Breakfast	Pay Now	8706898603750380065	South Korea	0	South Korea	1	1	KR	Korean	49.74	MasterCard	Credit Card	KRW	True	1D50P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4463	NaN	NaN	2567	2018-09-22
46924	-8952794303652718161	2018-04-05 22:41:00	2018-07-22 00:00:00	2018-07-24 00:00:00	276008	KR	2014-06-19 08:05:00	3.5	Hotel	Pay Later	2011401455184750047	Taiwan	0	Taiwan	3	1	TW	T. Chinese / Taiwan	140.12	Visa	Credit Card	TWD	True	7D50P_2D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1240	188.0	454.0	731	2018-04-05
46925	-4286304901316077629	2018-07-31 13:00:00	2018-08-01 00:00:00	2018-08-03 00:00:00	1573295	TW	2016-10-04 13:32:00	3.0	Hotel	Pay Now	7713317830746380044	Taiwan	1	Taiwan	2	1	TW	T. Chinese / Taiwan	87.30	MasterCard	Credit Card	TWD	True	2D100P	False	1.0	0.0	0.0	0.0	0.0	0.0	0.0	5208	NaN	NaN	2004	NaN
46926	8516014471330804625	2018-07-26 15:50:00	2018-08-29 00:00:00	2018-08-30 00:00:00	91737	IN	2009-06-28 02:02:00	3.5	Hotel	Pay Later	2430631550982440067	Bangladesh	1	Bangladesh	2	1	BD	English	58.01	MasterCard	Credit Card	USD	True	2D1N_1N	False	0.0	0.0	0.0	1.0	0.0	0.0	0.0	2597	NaN	NaN	2302	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator